UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'navUPikYZJLqYmkXt7e8I8BehDMHc5xgxCOH8+UBw0s='
WHERE
key_id = '07f64e8388d6f9de5916270cea9eb4df692124aaa27eb7d5db1e9c7b3941737f'
AND (
token = 'navUPikYZJLqYmkXt7e8I8BehDMHc5xgxCOH8+UBw0s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)