UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rB0OsFya4dz6kL4tYvU7d7wI+rxj5MPhv79jp6JIuZc='
WHERE
key_id = '42b5dd250521875a08d045b786dadae4565d72d735a641d921ad2eeb4a97fac1'
AND (
token = 'rB0OsFya4dz6kL4tYvU7d7wI+rxj5MPhv79jp6JIuZc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)