UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KZ9DCu/8sgoZtcN3QmhLtQC3TmndjC2KZI9gFs+ISW0='
WHERE
key_id = 'cce79fc3fdabae30c45bc6640cbae0b5d05c5c6f51e9fe7fcf84e0b5e8e59e06'
AND (
token = 'KZ9DCu/8sgoZtcN3QmhLtQC3TmndjC2KZI9gFs+ISW0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)