UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YlG+hhen0N1RSiFqzP3NEqbLGk2WLfpaSem/lVK0Ij8='
WHERE
key_id = 'c9ada7725ae417535bc36482eef36c1cbb878bec6863a79cff87f6b80327a8e0'
AND (
token = 'YlG+hhen0N1RSiFqzP3NEqbLGk2WLfpaSem/lVK0Ij8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)