UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Irt8b4YlFekXWfNfV68J/QZqwCEe0u9YpENXuJvMp+M='
WHERE
key_id = '7b54308e6f43b866621b5a9bf14c60e23bd4f31e6485edbce2a885f4ee8cebfe'
AND (
token = 'Irt8b4YlFekXWfNfV68J/QZqwCEe0u9YpENXuJvMp+M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)