UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R7dZ5labu6+/IJcP3hJsPNtxKeNuIVIW7rbcjkcJc9w='
WHERE
key_id = '7a8dd9309aac8ea31c547ea81ca15c87fdbc8ec93f57be9441f734a8eb482bc0'
AND (
token = 'R7dZ5labu6+/IJcP3hJsPNtxKeNuIVIW7rbcjkcJc9w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)