UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PZb1hbWO75GZ+0iqXD1gI7gKIYSqJEDWo0DLYcYuJwk='
WHERE
key_id = 'c99825ef0b564ac58b16b6b06bdabac530240c6bf9f09f9cc1c3bfca7a48736a'
AND (
token = 'PZb1hbWO75GZ+0iqXD1gI7gKIYSqJEDWo0DLYcYuJwk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)