UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z2dKqFCBMj9KxWlFLgauATEYeaFx6TXcIMblZkHO64E='
WHERE
key_id = 'e8f65dbfe778c3c13c1f9b1ea15538b20bfa9ec29f2df2e9e406760af5c56e3e'
AND (
token = 'Z2dKqFCBMj9KxWlFLgauATEYeaFx6TXcIMblZkHO64E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)