UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QXIC59fOw1B+N3GwTBufIy5Fxhj2/eP4vN/Rr9eVsPo='
WHERE
key_id = 'cc7f535d563a20b9d08bd7b15d2b19e99d9a7fdd945e9c0aa1f3b1ca7d1db720'
AND (
token = 'QXIC59fOw1B+N3GwTBufIy5Fxhj2/eP4vN/Rr9eVsPo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)