UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hKKpm4QmwDJp/jJ4mU51OKqxQ5FvcDLx7iiuWwU0upA='
WHERE
key_id = 'f7084ea7ac202bfef89ae78e1dc95fce79f28f8788ee88b2b16463621e2ad4a0'
AND (
token = 'hKKpm4QmwDJp/jJ4mU51OKqxQ5FvcDLx7iiuWwU0upA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)