UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8ZvU/X+Ed3k5dFERFNCW8LR4MRjD9PrXD4AP7soxGTA='
WHERE
key_id = '2b7aa4870a9facbf58fdae5a5a362c6162c600ea21cf2a5c9e7222300da89013'
AND (
token = '8ZvU/X+Ed3k5dFERFNCW8LR4MRjD9PrXD4AP7soxGTA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)