UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'M74W5hTI1yxzCQj6tQn+0xqjOVNahsICAT6KrBcOKw4='
WHERE
key_id = '3636d8def592c1076b1101cd44ca0eb66056a1ebe23f4285bfb0698d9603a899'
AND (
token = 'M74W5hTI1yxzCQj6tQn+0xqjOVNahsICAT6KrBcOKw4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)