UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/P5UzB09FTJHoh93d5deMBNoczlLndEqZQ1HbL6L+vw='
WHERE
key_id = 'd9189136c411607dc33b2f2b7919866f873f6f52ffb9a57edb4b3855932ff0ba'
AND (
token = '/P5UzB09FTJHoh93d5deMBNoczlLndEqZQ1HbL6L+vw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)