UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8OY4J4Yn08d/p8RiX3aW7V+7oD9dhjeob6aiaLnu7tA=' 
WHERE 
  key_id = '9ce1726d16185371915fc95381a29c2311f572c2759103b2d149aa76316a311d' 
  AND (
    token = '8OY4J4Yn08d/p8RiX3aW7V+7oD9dhjeob6aiaLnu7tA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045