UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QzQ+aIIEPkPMBoqVbex32ZA/Y3O8emAXc2q/6PfvYh0='
WHERE
key_id = '20c6d4b03ac299fd349680a8e5eb993c91656c5ebfb8214ca4506c2bcf4a4fdf'
AND (
token = 'QzQ+aIIEPkPMBoqVbex32ZA/Y3O8emAXc2q/6PfvYh0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)