UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G9q2UQ1ulD1vPwx5qsxZhfNWzRUWDGz8dcpCalDFJts='
WHERE
key_id = 'e80adcf7b886eddb5fb17610eb8f69c3818026bd0340cfd96667ffeb28e68509'
AND (
token = 'G9q2UQ1ulD1vPwx5qsxZhfNWzRUWDGz8dcpCalDFJts='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)