UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nCZMu+iiHd27VJG3gYHjxeINozMtUpB0/lXkPrx/XQU='
WHERE
key_id = 'cce4be83cc0b0331050862a0cb99398085b98f9dfaef7ecf194f8465ecd8ae47'
AND (
token = 'nCZMu+iiHd27VJG3gYHjxeINozMtUpB0/lXkPrx/XQU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)