UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AVSWf9osbQMWgP7VxCTQW1Ae1jIbCMvXeK2bxQWYmDs='
WHERE
key_id = '58b6771d09bdaee20812e31458a6d0c5568e28da4136142d1987ced20208c4c5'
AND (
token = 'AVSWf9osbQMWgP7VxCTQW1Ae1jIbCMvXeK2bxQWYmDs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)