UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'i4Av8W9UYUCnJ8XN3FVx/pfE+oQgFCNarterhABk9zM=' 
WHERE 
  key_id = '4af85980a82a65a0df13e55cfce5a0cb7dea7ad7c2203f4d04fe34eebf93a1fc' 
  AND (
    token = 'i4Av8W9UYUCnJ8XN3FVx/pfE+oQgFCNarterhABk9zM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041