UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HVB4vdph0zaRMKPZMDmNF4MSgZbZVC+dDDOTR/5P5OU='
WHERE
key_id = '547a9b9fc0c8a0c4eb2673982c5ff5d4a07f76fa9bc819c527c0b4e184b8588c'
AND (
token = 'HVB4vdph0zaRMKPZMDmNF4MSgZbZVC+dDDOTR/5P5OU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)