UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R24eSSOBigY3jwZiBLTZw4fxsjZ2Wiv/rAHWzQxksdk='
WHERE
key_id = '7ec42247e90ce67891bd2fc75d9df904f9eb4cd04c5eb422d71a6a5b94c63e21'
AND (
token = 'R24eSSOBigY3jwZiBLTZw4fxsjZ2Wiv/rAHWzQxksdk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)