UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'IcfwOio4d0lmucKzkREMd3B+cUspyy/w3+PiQfNwKL4=' 
WHERE 
  key_id = '6303cfa0f5f13beb3ea6452859953d9a6810faded42eb6e0f30e6eb9f03d1943' 
  AND (
    token = 'IcfwOio4d0lmucKzkREMd3B+cUspyy/w3+PiQfNwKL4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029