UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6QaIADrkYJwTcGnAO0GzFKsvLcKU15Gz62tTeE1dkTE='
WHERE
key_id = '8a46c8f9035d7e48b173305e8a5040f4f5b8d4483c09da39f9fe2c82e3be5bbf'
AND (
token = '6QaIADrkYJwTcGnAO0GzFKsvLcKU15Gz62tTeE1dkTE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)