UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p4NGEgGzxmYSYXrDzxU1TLvgYOXAAROYNcwjenECz7k='
WHERE
key_id = '74969d6b4de367aaa0bd8331cabb86459bea1ccf4827723dda447a03351de7f3'
AND (
token = 'p4NGEgGzxmYSYXrDzxU1TLvgYOXAAROYNcwjenECz7k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)