UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'raWNyvontuTR9EY7wIhOB1OvkH6YzA/VstAqpetZud8='
WHERE
key_id = 'a313ac59994921bdde1c2d9f0aa7c1cda47a9ba5c10ea25feb480d915d7e9f8e'
AND (
token = 'raWNyvontuTR9EY7wIhOB1OvkH6YzA/VstAqpetZud8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)