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