UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'At0rWJgrgIK+wRrZOCHIqEBsBrTqVVgllw3opEuuJ60='
WHERE
key_id = '9f5fb9ba621976c462fc630925194297f488358f69b2d25d6f9e247d2aa5704e'
AND (
token = 'At0rWJgrgIK+wRrZOCHIqEBsBrTqVVgllw3opEuuJ60='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)