UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oPUqmWEdbgX7XOH69THiOewAyW4Op1IqILmwqJA4LRs='
WHERE
key_id = 'ac66bb3c61b3cbe76de1ed10e6f7366dbafdaf792273546715b11fe1b4b6f6e7'
AND (
token = 'oPUqmWEdbgX7XOH69THiOewAyW4Op1IqILmwqJA4LRs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)