UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '43w9yWDl3dspcjpg5z4ue1euNooEDhnptffO20g5rbI='
WHERE
key_id = 'fdc4bbbb57e1a72efa30c6345fc6a835f8bdf9e788db72ee652e2c9233df3f05'
AND (
token = '43w9yWDl3dspcjpg5z4ue1euNooEDhnptffO20g5rbI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)