UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '3CHvliyh2mXrASruNP+n0VZDD00tAOoJp/neyRqwNHw=' 
WHERE 
  key_id = '8cea3752489f69d42daa6c7e50010cafe56d4aeb7140650d797224a64909ba7f' 
  AND (
    token = '3CHvliyh2mXrASruNP+n0VZDD00tAOoJp/neyRqwNHw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026