UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FtjRP5a6l28lyfKXb3Wfde/vAxAgriH9vdpbHI38l7w='
WHERE
key_id = '1067ad4ce6678164b2ea238068c1a8673ce54028a829fee4f246bb0fa5af5bea'
AND (
token = 'FtjRP5a6l28lyfKXb3Wfde/vAxAgriH9vdpbHI38l7w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)