UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JzCXGOGnSP6p5jpo3KGat6kiOiP6IE2P6mvu5si+gSY='
WHERE
key_id = 'c79818ec8cecec8d7993a958526616b61804ac39f29eebf1c2ee6e19b634daf2'
AND (
token = 'JzCXGOGnSP6p5jpo3KGat6kiOiP6IE2P6mvu5si+gSY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)