UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'WWXl30j1S9Xvx6akf7lY0pUVZHFOWxOwSsr9Jei2ZFE=' 
WHERE 
  key_id = 'ea61b8c919198325d6c6faeb77abedeea9357912a493182369c6fd529d0db0fa' 
  AND (
    token = 'WWXl30j1S9Xvx6akf7lY0pUVZHFOWxOwSsr9Jei2ZFE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033