UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nlrkDSX6bH/2BjiRPWdAIsoa5sshxEPmoWWv/j7jod0='
WHERE
key_id = 'be7be1466dd227221bfe45835f175468259301a0af5feca5fd0b8c60cc32965a'
AND (
token = 'nlrkDSX6bH/2BjiRPWdAIsoa5sshxEPmoWWv/j7jod0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)