UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'id2TPOP/hcZZ1rSCPXCrcoFFtMGvDrm4g7zq02/u5+g='
WHERE
key_id = '1b9fe3254440ac6211a37891ad51b5b9060fa8a3d6ba66b650a5bde98aff38ab'
AND (
token = 'id2TPOP/hcZZ1rSCPXCrcoFFtMGvDrm4g7zq02/u5+g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)