UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'jsLz06b48zGS/1/i4TAG3gLr/x++mozE9bw3/QA4cDg=' 
WHERE 
  key_id = '2c942b0b86f7da5793ec0f2b806618c3b335ad181e4e75f763909a0e26f3f4b3' 
  AND (
    token = 'jsLz06b48zGS/1/i4TAG3gLr/x++mozE9bw3/QA4cDg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028