UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'zQh9y7OrTFcf+Kd46nQGAK2DFUHj1PtrDX3nFD3o+zY=' 
WHERE 
  key_id = 'a68177c2048da39f90d9f2859d16239b8b5c376a6975ea8c84fa5b1a598cec78' 
  AND (
    token = 'zQh9y7OrTFcf+Kd46nQGAK2DFUHj1PtrDX3nFD3o+zY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041