UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YV8b1pu8bt8EKiaaIKYrjDDI94xBwQoY6YtFdZlIUxE='
WHERE
key_id = 'a0b314aaae760a8cff9d5ef2300cee799b8625bfb65f4fbf8ea3a0fdc4831a79'
AND (
token = 'YV8b1pu8bt8EKiaaIKYrjDDI94xBwQoY6YtFdZlIUxE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)