UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ZIY8s+9T1ORthoosXyJdIkcRzM8s3hN0cLJBb+mSwKI=' 
WHERE 
  key_id = '070261606572b7da6434c864f9955359cfe45c74811669636b035d58757b6546' 
  AND (
    token = 'ZIY8s+9T1ORthoosXyJdIkcRzM8s3hN0cLJBb+mSwKI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036