UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pI2CZqnxP0aqSWR3hEZMQ8pEP0cyllPM//In4hGuflM='
WHERE
key_id = 'f7a8cc6ed939a440feb2a901eead33a80048d186c96b33bbb0f5cf3c8321a97c'
AND (
token = 'pI2CZqnxP0aqSWR3hEZMQ8pEP0cyllPM//In4hGuflM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)