UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nd7MekqS8mWTV30f3u4XXE23oDEg/gA9H7qwq+1S4y0='
WHERE
key_id = 'cbe234a3aca1703d5a62380391766ce6f0411f3913b19199e7f506234799349f'
AND (
token = 'nd7MekqS8mWTV30f3u4XXE23oDEg/gA9H7qwq+1S4y0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)